CREATE PROCEDURE [dbo].[sp_cat_GetRole]
@Role varchar(50) = NULL, @PKRole int = NULL
AS
BEGIN
  SELECT PKRole , Role FROM SC_Role
  WHERE PKRole = COALESCE(@PKRole , PKRole)
  AND Role = COALESCE(@Role , Role)
  ORDER BY Role;
END